Skip Headers

Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2) Part Number B14191-02 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J K L M N O P R S T U V W

## A

  ABORT option
    SHUTDOWN statement, 18.5.1.1, 18.5.1.2, 18.8.1, 18.10.1, 18.10.2
  active online redo log
    loss of group, 19.8.2.2, 19.8.2.2
  alert log, 19.11.1
    checking after RESETLOGS, 18.9.3
    useful for RMAN, 12.1.1
  ALLOW ... CORRUPTION clause
    RECOVER command, 21.5
  ALTER DATABASE statement
    BACKUP CONTROLFILE clause, 17.5.2
      TO, 17.5.2
    CLEAR LOGFILE clause, 19.8.2.1.3
    END BACKUP clause, 17.4.3.1
    NORESETLOGS option, 18.9.2
    OPEN RESETLOGS clause, 10.2.3
    RECOVER clause, 18.4.2, 18.6.6
    RESETLOGS option, 18.9.2, 18.9.2, 18.10.1, 18.10.2
  ALTER SYSTEM statement
    KILL SESSION clause, 12.3.1
    RESUME clause, 17.7.2
    SUSPEND clause, 17.7.2, 17.7.2
  ALTER TABLESPACE statement
    BEGIN BACKUP clause, 17.4.1, 17.4.2.2
    END BACKUP option, 17.4.2.2
  archived redo logs
    applying during media recovery, 18.6
    automating application, 18.6.2.1, 18.6.2.2
    backing up, 6.9.6
    cataloging, 10.2.1.2
    changing default location, 18.6.5
    corrupted, 21.1
    deleting after recovery, 18.4.2
    deletion after backup, 2.2.4.1, 9.3.2.4
    deletion after restore, 3.2.2.1
    errors during recovery, 18.6.7
    incompatible format, 21.1
    location during recovery, 18.6
    loss of, 19.9
    restoring, 18.4.2
    RMAN fails to delete, 12.4.6
    using for recovery
      in default location, 18.6.3
      in nondefault location, 18.6.6
  ARCHIVELOG mode
    datafile loss in, 19.1.2, 19.1.2
  AS SELECT clause
    CREATE TABLE statement, 19.5
  autobackups
    control file, 2.6, 2.6.2.1
    server parameter file, 2.6
  automatic channels, 2.1
    allocation, 2.1
    configuring, 5.3, 5.3.1, 5.3.4, 6.1
    generic
      configuring, 2.1.5, 5.3.2
      definition, 5.3.2
    naming conventions, 2.1.4
    overriding, 5.3
    parallelism, 5.3.1
    specific configurations, 2.1.6, 2.1.6
  AUTORECOVERY option
    SET statement, 18.6.2
  auxiliary instance parameter file
    with TRANSPORT TABLESPACE, 14.3.4

## B

  BACKUP
    and corrupt datafile blocks and MAXCORRUPT, 2.11.2
    AS COPY
      and DB_FILE_NAME_CONVERT, 2.4.2
      and output filenames, 2.4.2
      FORMAT, 2.4.2
    image copy
      and output filenames, 2.4.2
    INCREMENTAL
      FROM SCN, 13.8
    INCREMENTAL FROM SCN, 13.8.1
    output filenames
      image copies, 2.4.2
  BACKUP command, 6.9.13
    BACKUPSET option, 2.3.2, 6.4
    DELETE INPUT option, 9.3.3
    FORMAT parameter, 2.4.1
    KEEP option, 2.7.4
    NOT BACKED UP SINCE clause, 2.9, 6.7
    PROXY ONLY option, 2.2.2
    PROXY option, 2.2.2
    SKIP OFFLINE option, 6.9.1, 6.9.1
    VALIDATE option, 2.12.4
  BACKUP CONTROLFILE clause
    of ALTER DATABASE, 17.1.1
  BACKUP CONTROLFILE TO TRACE clause
    of ALTER DATABASE, 17.1.1
  BACKUP COPIES parameter
    CONFIGURE command, 5.6
  backup encryption, 6.6.1
    dual-mode, 6.6.1.3
    overview, 6.6
    password, 6.6.1.2
    transparent, 6.6.1.1
  backup mode
    ending with ALTER DATABASE END BACKUP, 17.4.3.1
    for online user-managed backups, 17.4.1
    instance failure, 17.4.3
  backup optimization
    configuring, 5.5
    definition, 2.8, 6.7
    disabling, 2.8.3, 5.5
    enabling, 2.8.3, 5.5
    recovery window and, 2.8.5.1
    redundancy and, 2.8.5.2
    retention policies and, 2.8.5
  BACKUP OPTIMIZATION option
    of CONFIGURE, 6.7
  backup retention policy
    definition, 2.7
  backup sets
    backing up, 2.3.2, 6.4
    configuring maximum size, 5.4
    crosschecking, 9.2
    duplexing, 6.2
    errors during creation, 2.11
    failover during backups, 2.3.2.3
    how RMAN generates, 2.4.5
    limiting size, 2.4.5
    multiplexing, 2.2.5
    naming, 2.4.1
    specifying maximum size (in bytes), 2.4.4
    specifying number of, 2.4.5
  Backup Solutions Program (BSP), 1.4.2
  backups
    archived redo logs, 6.9.6
      deletion after backing up, 9.3.2.4
    availability
      altering with CHANGE command, 9.4
    backup sets, 6.4
    backups of, 2.3.2
    closed, 17.2.1
    consistent, 17.2
    control files, 17.5, 17.5
      binary, 17.5.1
      trace files, 17.5.2
    correlating RMAN channels with, 9.6.1.2.1, 9.6.1.2.2
    cumulative incremental, 2.5.1.4, 3.4
    datafile
      using RMAN, 6.4, 6.7.1, 6.7.2
    DBVERIFY utility, 17.9
    deleting, 9.3.2
    determining datafile status, 17.1.2
    duplexing, 5.6, 6.2
    excluding tablespaces from backups, 5.7
    failed RMAN, 12.4.7
    failover during BACKUP BACKUPSET, 2.3.2.3
    hung, 12.4.2
    image copies, 2.2.1
    inconsistent, 17.2
    incremental, 2.5.1
      differential, 2.5.1.3
      using RMAN, 6.2.1, 6.2.2
    interrupted, 6.7
    keeping, 6.9.11
    keeping records, 17.12
    limiting I/O rate, 2.4.6
    listing files needed, 17.1
    logical, 17.10
    long-term, 2.7.4, 2.7.4
      changing status, 9.5
    multiple copies, 5.6
    NOARCHIVELOG mode, in, 6.9.10
    obsolete
      batch deletes, 2.7.3
    offline datafiles, 17.3
    offline tablespaces, 17.3, 17.3
    optimizing, 2.8
    read-only tablespaces, 17.4.4
    recovery catalog, 1.3.2.4, 10.6.1
    restartable, 2.9, 6.7
    restoring user-managed, 18.2
    RMAN error handling, 6.9.13
    specifying number of files in a backup set, 2.4.5.1
    split mirror, 2.2.1.2
      using RMAN, 6.3
    stored scripts, 10.5
    tablespace, 17.4.2
      using RMAN, 6.4, 6.7.1, 6.7.2
    tags, 2.4.3
    testing RMAN, 2.12.4, 6.8
      using media manager, 5.2.3.4
    troubleshooting failed RMAN, 12.4.1, 12.4.4, 12.4.5
    types, 2.5
    Updating standby databases with incrementals, 13.8.1
    user-managed, 17
      restoring, 18.4.1
    validating, 6.8
    verifying, 17.9
    whole database
      preparing for, 17.2.1
  BEGIN BACKUP clause
    ALTER TABLESPACE statement, 17.4.1
  block corruptions
    stored in V$DATABASE_BLOCK_CORRUPTION, 6.8
  block media recovery, 7.5
    guidelines, 3.3.1
    overview, 3.3
  BLOCKRECOVER command, 3.3, 7.5
  BSP. See Backup Solutions Program (BSP)

## C

  cancel-based media recovery
    procedures, 18.7.2, 18.8.4
  canceling RMAN commands, 12.3
  CATALOG command, 10.2.1.2
  cataloging
    archived redo logs, 10.2.1.2
    datafiles, 10.2.1.2
  catalog.sql script, 10.1.2
  catproc.sql script, 10.1.2
  CHANGE command, 9.2
    AVAILABLE option, 9.4
    KEEP option, 9.5
  change-based media recovery
    coordinated in dis, 19.11.1
  channels
    allocating manually for backups, 6.1
    configuring automatic, 5.3
    configuring for backups, 6.1
    control options, 2.1.9
    definition, 2.1
    difference between manual and automatic, 2.1.1
    generic configurations, 2.1.5
    overriding automatic, 5.3
    parallelism for manual channels, 2.1.8
    preconfigured disk, 5.3
    Recovery Manager, 2.1
    RMAN naming conventions, 2.1.4
    specific configurations, 2.1.6
  circular reuse records, 1.3.1.1
  CLEAR LOGFILE clause
    of ALTER DATABASE, 19.8.2.1.3
  clearing RMAN configuration, 2.1.7, 5.3.5
  clone databases
    preparing for TSPITR, 20.3.1, 20.3.2
  cold failover cluster
    definition, 17.4.3
  command files
    Recovery Manager, 1.2.2.2
  command interface
    RMAN, 1.2
  commands, Recovery Manager
    BACKUP, 6.9.13
      PROXY ONLY option, 2.2.2
      PROXY option, 2.2.2
      SKIP OFFLINE option, 6.9.1
    batch execution, 1.2.2.2
    CATALOG, 10.2.1.2
    CHANGE, 9.2
    CONFIGURE, 2.1.5, 2.1.7
    DELETE, 9.3.2
    DROP CATALOG, 10.12
    DUPLICATE, 3.4
    EXECUTE SCRIPT, 10.5
    how RMAN interprets, 1.2
    interactive, 1.2.2.1
    LIST, 9.1.1
      INCARNATION option, 10.2.3
    piping, 4.7
    RECOVER, 3.2
    RESET DATABASE
      INCARNATION option, 10.2.3
    RESYNC CATALOG, 10.3
      FROM CONTROLFILECOPY option, 10.6.3
    SET
      MAXCORRUPT option, 6.9.13
    SHOW, 2.1.2
    standalone, 1.2.2.5
    terminating, 12.3, 12.3
    UPGRADE CATALOG, 10.11
  commands, SQL
    ALTER DATABASE, 18.4.2, 18.6.6
  commands, SQL*Plus
    RECOVER
      UNTIL TIME option, 18.8.4
    SET, 18.4.2, 18.6.2, 18.6.6
  compatibility
    recovery catalog, 1.3.2.5
  compilation
    and execution of RMAN commands, 1.2.1
  complete recovery
    procedures, 18.7
  CONFIGURE command
    BACKUP OPTIMIZATION option, 5.5
    CHANNEL option, 2.1.5
    CLEAR option, 2.1.7, 5.3.5
    DEFAULT DEVICE TYPE clause, 2.1.3
    DEVICE TYPE clause, 2.1.2
    EXCLUDE option, 5.7
    RETENTION POLICY clause, 2.7, 2.7
  configuring
    media manager
      installing, 5.2.1
      prerequisites, 5.2.1
    media managers for use with RMAN, 5.2.3.1
    Recovery Manager
      autobackups, 2.6
      automatic channels, 5.3, 5.3.2
      backup optimization, 5.5
      backup set size, 5.4
      clearing, 2.1.7, 5.3.5
      default device types, 2.1.3
      device types, 2.1.2
      parallelism, 2.1.2
      shared server, 5.10
      snapshot control file location, 5.9
      specific channels, 5.3.4
      tablespace exclusion for backups, 5.7
  consistent backups
    whole database, 17.2
  control file autobackups
    after structural changes to database, 2.6
    configuring, 2.6
    default format, 2.6.1
    restoring, 2.6
  control files
    automatic backups, 2.6.2.1
      configuring, 2.6
    backing up to trace file, 17.5.2.1
    backups, 17.1.1, 17.5
      binary, 17.5.1
      recovery using, 7.3
      trace files, 17.5.2
    creating after loss of all copies, 18.5.3
    duplicate database, 13.2.1
    finding filenames, 17.1.1
    multiplexed
      loss of, 18.5.1
    recreated, 18.5.3
    restoring
      to default location, 18.5.1.1
      to nondefault location, 18.5.1.2
      using SET DBID, 7.6.2
    snapshot
      specifying location of, 5.9
    time-based recovery, 18.8.2
    types of records, 1.3.1.1
    user-managed restore after loss of all copies, 18.5.3
    using instead of a recovery catalog, 1.3.1
  CONTROL_FILES initialization parameter, 8.5.1.2, 18.5.1.2
  CONVERT command
    and DB_FILE_NAME_CONVERT, 15.1.1
    moving data to/from ASM, 15.4
    with databases, 15.2
    with tablespaces and datafiles, 15
  CONVERT DATABASE, 15.2
  CONVERT DATAFILE
    moving to/from ASM, 15.4
  CONVERT DATAFILE or TABLESPACE, 15.1
  CONVERT TABLESPACE
    moving to/from ASM, 15.4
  coordinated time-based recovery
    distributed databases, 19.11.1
  COPIES option
    of BACKUP, 6.2.2
  corrupt datafile blocks, 2.12.1
    detecting, 2.12.1, 2.12.2
    records in control file, 2.11.2
    recovering, 7.5.3
    RMAN and, 2.11.1
    setting maximum for backup, 6.9.13
  corrupt datafile blocks during backup, 2.11.2
  corruption detection, 2.12.2
  CREATE DATAFILE clause
    of ALTER DATABASE, 19.3
  CREATE TABLE statement
    AS SELECT clause, 19.5
  CREATE TABLESPACE statement, 19.2
  creating
    test databases, 3.4
  crosschecking
    definition, 9.2
    recovery catalog with the media manager, 9.2
  cross-platform transportable database, 15.2
    transport script, 15.3.2.1
  cross-platform transportable tablespace, 15
  cumulative incremental backups, 2.5.1.4

## D

  data blocks
    corrupted, 21.1
  data dictionary views, 17.3, 17.4.1, 17.4.4
  Data Pump Export utility, 17.10
    backups, 17.10
  Data Pump Import utility, 17.10
  database connections
    Recovery Manager
      auxiliary database, 4.3
      hiding passwords, 4.5
  database incarnation, 18.9
  database point-in-time recovery (DBPITR)
    user-managed, 18.8
  databases
    listing for backups, 17.1
    media recovery procedures, user-managed, 18
    media recovery scenarios, 19
    recovery
      after control file damage, 18.5.1.1, 18.5.1.2
    registering in recovery catalog, 10.2.1, 10.2.1
    suspending, 17.7.1
    unregistering in recovery catalog, 10.2.2
  datafile recovery
    definition, 3.2
  datafiles
    backing up
      offline, 17.3
      using Recovery Manager, 6.4, 6.7.1, 6.7.2
    cataloging, 10.2.1.2
    determining status, 17.1.2
    duplicate database, 13.2.3
    listing
      for backup, 17.1
    losing, 19.1
      in ARCHIVELOG mode, 19.1.2
      in NOARCHIVELOG mode, 19.1.1
    recovery
      basic steps, 3.2.1
      without backup, 19.3
    re-creating, 19.3
    renaming
      after recovery, 19.2
    restoring, 3.1, 18.4.1
      to default location, 18.4.1
  db identifier
    problems registering copied database, 10.2.1.2
    setting during disaster recovery, 7.3.1
    setting with DBNEWID, 10.2.1.2
  DB_FILE_NAME_CONVERT
    and CONVERT command, 15.1.1
  DB_FILE_NAME_CONVERT initialization parameter, 8.5.1.2, 20.2.6
    using with RMAN DUPLICATE command, 13.2.3, 13.2.4, 13.2.4
  DB_NAME initialization parameter, 8.5.1.2
  DBA_DATA_FILES view, 17.3, 17.4.1, 17.4.4
  DBMS_PIPE package, 4.7
    using with RMAN, 4.7
  DBNEWID utility, 10.2.1.2
  DBVERIFY utility, 17.9
  DELETE command, 9.3.2
    OBSOLETE option, 2.7.3
  deleting
    expired backups, 9.3.2.3
    files after backups, 9.3.3
    obsolete backups, 9.3.2.2
    using RMAN, 9.3.1
  device types
    configuring in RMAN, 5.3.1
  differential incremental backups, 2.5.1.3
  disk API, 5.2.3
  disk channels
    preconfigured, 5.3
  distributed databases
    change-based recovery, 19.11.1
    coordinated time-based recovery, 19.11.1
    recovery, 19.11, 19.11
  dropping the recovery catalog, 10.12
  dual mode backup encryption, 6.6.1.3
  dummy API, 5.2.3
  duplexing
    backup sets, 2.3.1, 5.6, 6.2
  DUPLICATE command, 3.4
  duplicate database
    synchronizing
      using DUPLICATE DATABASE, 13.7
      using incremental backups, 13.8
  duplicate databases
    creating, 3.4
      on local host, 13.5.3
      on remote host with different file system, 13.5.2
      on remote host with same file system, 13.5.1
      past point-in-time, 13.6.4
      using CONFIGURE AUXNAME, 13.5.2.4
      using init.ora parameter and LOGFILE, 13.5.2.2
      using SET NEWNAME, 13.5.2.3
    datafiles, 13.2.3
    excluding tablespaces, 3.4, 13.1.2
    failed creation, 12.4.10
    generating control files, 13.2.1
    generating filenames, 13.2
    how RMAN creates, 13.1.1
    NOFILENAMECHECK option, 13.2.3.1
    preparing for duplication, 13.4
    skipping offline normal tablespaces, 13.3.2
    skipping read-only tablespaces, 13.3.1
  duplicating a database, 3.4
    troubleshooting, 12.4.10

## E

  endian formats
    and CONVERT DATAFILE/TABLESPACE, 15.1
  environment, Recovery Manager
    definition, 1.1
  error codes
    media manager, 12.1.3.2
    RMAN, 12.1, 12.1.3
      message numbers, 12.1.3.1
  error messages
    Recovery Manager
      interpreting, 12.1.4
  error stacks
    interpreting, 12.1.4
  errors
    during RMAN backups, 6.9.13
  EXCLUDE option
    of CONFIGURE, 5.7
  expired backups
    deleting, 9.3.2.3

## F

  FAST_START_MTTR_TARGET
    and tuning instance recovery, 11.4.4
  Fast-Start checkpointing architecture, 11.4.3
  Fast-Start Fault Recovery, 11.4, 11.4.3
  features, new, Preface
  fileNameConversionSpec
    and CONVERT command, 15.1.1
  filenames
    listing for backup, 17.1
  FORCE option
    DELETE command, 9.3.5
  fractured blocks
    definition, 2.12.3
    detection, 2.12.3

## G

  generic channels
    definition, 5.3.2
  groups
    archived redo log, 19.8.1, 19.8.2
    online redo log, 19.8.1, 19.8.2

## H

  hot backup mode
    for online user-managed backups, 17.4.1
  hot backups
    failed, 17.4.3
      ending with ALTER DATABASE END BACKUP, 17.4.3.1

## I

  image copies, 2.2.1
    and SWITCH commands, 2.2.1.1
  inactive online redo log
    loss of, 19.8.2.1
  INCARNATION option
    of LIST, 10.2.3
    of RESET DATABASE, 10.2.3
  incomplete media recovery, 18.8
    in Oracle Real Application Clusters configuration, 18.6.2.2
    time-based, 18.8.4
    with backup control file, 18.6.2.2
  incomplete recovery
    overview, 3.2.3
  incremental backups
    differential, 2.5.1.3
    how RMAN applies, 3.2.2
    using RMAN, 6.2.1, 6.2.2
  Incremental Roll Forward of Database Copy, 13.8
  initialization parameter file, 3.2
  initialization parameters
    CONTROL_FILES, 18.5.1.2
    DB_FILE_NAME_CONVERT, 8.5.1.2
    DB_NAME, 8.5.1.2
    LARGE_POOL_SIZE, 11.3.3
    LOCK_NAME_SPACE, 8.5.1.2
    LOG_ARCHIVE_DEST_n, 18.6.3
    LOG_ARCHIVE_FORMAT, 18.6.3
    LOG_FILE_NAME_CONVERT, 8.5.1.2
    RECOVERY_PARALLELISM, 18.11
  instance failures
    in backup mode, 17.4.3
  instance recovery
    Fast-Start Fault Recovery, 11.4.3
    performance tuning, 11.4
  integrity checks, 2.12
  interpreting RMAN error stacks, 12.1.4
  interrupting media recovery, 18.6.8
  I/O errors
    effect on backups, 2.11.1
    ignoring during deletions, 9.3.5

## J

  jobs
    RMAN
      monitoring performance, 9.6.4
      monitoring progress, 9.6.2

## K

  KEEP option
    of BACKUP, 2.7.4
    of CHANGE, 9.5

## L

  level 0 incremental backups, 2.5.1.2
  LIST command, 9.1.1
    INCARNATION option, 10.2.3
  LOCK_NAME_SPACE initialization parameter, 8.5.1.2
  log sequence numbers
    requested durin, 18.6
  LOG_ARCHIVE_DEST_n initialization parameter, 18.6.3, 20.2.6
  LOG_ARCHIVE_FORMAT initialization parameter, 18.6.3, 20.2.6
  LOG_FILE_NAME_CONVERT initialization parameter, 8.5.1.2, 20.2.6
  logical backups, 17.10
  LOGSOURCE variable
    SET statement, 18.4.2, 18.6.6
  long waits
    defined, 11.3.5.2
  long-term backups
    changing status, 9.5
    definition, 2.7.4, 2.7.4
  loss of
    inactive log group, 19.8.2.1

## M

  managing RMAN metadata, 10, 13
  MAXCORRUPT setting, 2.11.2
  MAXPIECESIZE parameter
    SET command, 5.2.3.2.2
  MAXSETSIZE parameter
    BACKUP command, 5.4
    CONFIGURE command, 5.4
  MAXSIZE parameter
    RECOVER command, 3.2.2.1
  mean time to recovery (MTTR)
    definition, 3.3
  media failures
    archived redo log file loss, 19.9
    complete recovery, 18.7
    complete recovery, user-managed, 18.7
    control file loss, 18.5.3
    datafile loss, 19.1
    NOARCHIVELOG mode, 18.10
    online redo log group loss, 19.8.2
    online redo log loss, 19.8.1
    online redo log member loss, 19.8.1
    recovery, 18.7
      distributed databases, 19.11
    recovery procedures
      examples, 19.1
  media management
    backing up files, 1.4.1
    Backup Solutions Program, 1.4.2
    crosschecking, 9.2
    error codes, 12.1.3.2
    linking to software, 5.2.2
    sbttest program, 12.2.1
    testing the API, 12.2
  media managers
    configuring for use with RMAN, 5.2.3.1
    installing, 5.2.1
    linking
      testing, 5.2.3
    prerequisites for configuring, 5.2.1
    testing, 5.2.3
    testing backups, 5.2.3.4
    troubleshooting, 5.2.3.4
  media recovery
    ADD DATAFILE operation, 19.2
    after control file damage, 18.5.1.1, 18.5.1.2
    applying archived redo logs, 18.6
    cancel-based, 18.7.2, 18.8, 18.8.4
    ch, 18.8
    complete, 18.7
      closed database, 18.7.1
    complete, user-managed, 18.7
    corruption
      allowing to occur, 21.4
    datafiles
      basic steps, 3.2.1
      without backup, 19.3
    distributed databases, 19.11
    errors, 18.6.7, 18.6.7, 21.1
    incomplete, 18.8
    interrupting, 18.6.8
    lost files
      lost archived redo log files, 19.9
      lost datafiles, 19.1
      lost mirrored control files, 18.5.1
    NOARCHIVELOG mode, 18.10, 18.10
    offline tablespaces in open database, 18.7.2
    online redo log files, 19.8
    opening database after, 18.9, 18.9.2
    parallel, 18.11
    problems, 21.1, 21.1
      fixing, 21.3
      investigating, 21.2
    restarting, 18.6.8
    restoring
      archived redo log files, 18.4.2
      whole database backups, 18.10
    resuming after interruption, 18.6.8
    roll forward phase, 18.6
    scenarios, 19
    time-based, 18.8
    transportable tablespaces, 19.7
    trial, 21.6
      explanation, 21.6.1
      overview, 21.6
    troubleshooting, 21.1
      basic methodology, 21.1
    types
      distributed databases, 19.11
    undamaged tablespaces online, 18.7.2
    unsuccessfully applied redo logs, 18.6.7
    using Recovery Manager, 3.2
  media recovery, user-managed, 18
  metadata
    managing RMAN, 1.3, 10, 13
    querying RMAN, 9.1
    storing in control file, 1.3.1
  mirrored files
    online redo log
      loss of, 19.8.1
    splitting, 17.7.1
      suspend/resume mode, 17.7.1
      using RMAN, 6.3
  mirroring
    backups using, 6.3
  modes
    NOARCHIVELOG
      recovery from failure, 18.10
  monitoring RMAN, 9.6
  MOUNT option
    STARTUP statement, 18.8.2, 18.8.3
  multiplexed files
    control files
      loss of, 18.5.1
  multiplexing
    datafiles with Recovery Manager, 2.2.5

## N

  naming backup sets, 2.4.1
  new features, Preface
  NOARCHIVELOG mode
    backing up, 6.9.10
    datafile loss in, 19.1.1
    disadvantages, 18.10
    recovery, 18.10
  noncircular reuse records, 1.3.1.1
  NOT BACKED UP SINCE clause
    BACKUP command, 6.7
  not feasible to test 1 oct 04 nocheck, 5.2.3.1

## O

  obsolete backups
    deleting, 2.7.3, 9.3.2.2
    different from expired backups, 2.7
    reporting, 9.1.2.1
  online redo logs, 19.8.2.1
    active group, 19.8.1, 19.8.2
    applying during media recovery, 18.6
    archived group, 19.8.1, 19.8.2
    clearing
      failure, 19.8.2.1.3
    clearing inactive logs
      archived, 19.8.2.1.1
      unarchived, 19.8.2.1.2
    current group, 19.8.1, 19.8.2
    determining active logs, 19.8.2
    inactive group, 19.8.1, 19.8.2
    listing log files for backup, 17.1.1
    loss of
      active group, 19.8.2.2, 19.8.2.2
      all members, 19.8.2
      group, 19.8.2
      mirrored members, 19.8.1
      recovery, 19.8
    multiple group loss, 19.8.2.3
    replacing damaged member, 19.8.1
    status of members, 19.8.1, 19.8.2
  online tablespace transport, 14
  OPEN RESETLOGS clause
    ALTER DATABASE statement, 10.2.3
  operating system copies
    definition, 2.2.1.2
  ORA-01578 error message, 19.5
  Oracle Encryption Wallet
    and backups, 6.6.1.1

## P

  packages
    DBMS_PIPE, 4.7, 4.7
  parallel recovery, 18.11
  parallelism
    backups, 2.2.7
    configuring RMAN, 2.1.2, 5.3.1
    manually allocated RMAN channels, 2.1.8
  partitioned tables
    dropped partitions, 20.6
    performing partial TSPITR, 20.5
    split partitions, 20.7
  password backup encryption, 6.6.1.2
  password files
    connecting to Recovery Manager with, 4.2
  passwords
    connecting to RMAN, 4.5
  performance tuning
    backup performance, 11.3
    disk bandwidth and RATE channel parameter, 11.2.1
    Fast-Start Fault Recovery, 11.4
    instance recovery, 11.4
      FAST_START_MTTR_TARGET, 11.4.3
      setting FAST_START_MTTR_TARGET, 11.4.4
      using V$INSTANCE_RECOVERY, 11.4.3.3
    LARGE_POOL_SIZE initialization parameter, 11.3.3
    long waits
      defined, 11.3.5.2
    short waits
      definition of, 11.3.5.2
  pipe interface, 4.7
  point of recoverability
    recovery window, 2.7.1
  point-in-time recovery, 18.8
    tablespace, 8, 8.1.2, 8.1.2.1, 20.4.2
      user-managed, 20
  PROXY ONLY option
    of BACKUP, 2.2.2
  PROXY option
    of BACKUP, 2.2.2

## R

  RATE option
    of ALLOCATE CHANNEL, 2.4.6
    of CONFIGURE CHANNEL, 2.4.6
  raw devices
    backing up to, 17.8
    restoring to, 18.4.1
    UNIX backups, 17.8.1
    Windows backups, 17.8.2
  read-only tablespaces
    backing up, 6.9.1
    backups, 17.4.4
  Recov, 10.2.3
  RECOVER clause
    of ALTER DATABASE, 18.4.2, 18.6.6
  RECOVER command, 3.2, 3.2.2.1
    unrecoverable objects and standby databases, 19.5
    UNTIL TIME option, 18.8.4
    USING BACKUP CONTROLFILE clause, 19.6
  RECOVER SQL*Plus statement
    PARALLEL and NOPARALLEL options, 18.11
  recovery
    ADD DATAFILE operation, 19.2
    automatically applying archived logs, 18.6.2
    cancel-based, 18.7.2, 18.8.4
    complete, 18.7
      closed database, 18.7.1
      offline tablespaces, 18.7.2
    corruption
      intentionally allowing, 21.4
    data blocks, 3.3, 7.5
      guidelines, 3.3.1
    database
      in NOARCHIVELOG mode, 7.1.1
    database files
      how RMAN applies changes, 3.2.2
      overview, 3.2
    datafile without a backup, 7.6.3
    datafiles, 19.1
      ARCHIVELOG mode, 19.1.2
      NOARCHIVELOG mode, 19.1.1
    determining files needing recovery, 18.3
    disaster using RMAN, 7.4
    dropped table, 19.10
    errors, 21.1
    interrupting, 18.6.8
    media, 18, 19, 21
    multiple redo threads, 18.6.2.2
    of lost or damaged recovery catalog, 10.6.3
    online redo logs, 19.8
      losing member, 19.8.1
      loss of group, 19.8.2
    opening database after, 18.9
    parallel, 18.11
    parallel processes for, 18.11
    problems, 21.1
      fixing, 21.3
      investigating, 21.2
    responding to unsuccessful, 18.6.7
    setting number of processes to use, 18.11
    stuck, 21.1
    time-based, 18.8.4
    transportable tablespaces, 19.7
    trial, 21.6
      explanation, 21.6.1
      overview, 21.6
    troubleshooting, 21.1
    user errors, 19.10
    user-managed, 18, 19, 21
    using backup control file, 7.3
      without recovery catalog, 7.3.1
    using logs in a nondefault location, 18.6.5
    using logs in default location, 18.6.3
    using logs in nondefault location, 18.6.6
    without a recovery catalog, 1.3.1.2
  recovery catalog, 1.3.2
    availability, 10.8
    backing up, 1.3.2.4, 10.6.1
    compatibility, 1.3.2.5
    contents, 1.3.2.2
    crosschecking, 9.2
    db identifier problems, 10.2.1.2
    dropping, 10.12
    managing size of, 10.4
    moving to new database, 10.7
    operating with, 1.3
    operating without, 1.3.1
    recovery of, 10.6.3
    refreshing, 10.3
    registering target databases, 1.3.2.1, 10.2.1, 10.2.1
    resynchronizing, 10.3
    snapshot control file, 1.3.2.3.1
    space requirements, 10.1.1.2
    stored scripts
      creating, 10.5.1
    synchronization, 1.3.2.3
    UNKNOWN database name, 12.4.12
    unregistering databases, 10.2.2
    updating
      after schema changes, 10.3.3.3
    upgrading, 10.11
    views
      querying, 10.9
  Recovery Manager
    allocating disk buffers, 11.1.1
    allocating tape buffers, 11.1.1.2
    backup sets
      backing up, 6.4
    backup types
      duplexed backup sets, 2.3.1
    backups
      backing up, 2.3.2
      batch deletion of obsolete, 2.7.3
      control file autobackups, 2.6.2.1
      datafile, 6.4, 6.7.1, 6.7.2
      image copy, 2.2.1
      incremental, 6.2.1, 6.2.2
      long-term, 2.7.4
      optimization, 2.8
      restartable, 2.9
      tablespace, 6.4, 6.7.1, 6.7.2
      testing, 2.12.4, 6.8
      types, 2.5
      using tags, 2.4.3
      validating, 6.8
    channels, 2.1
      generic configurations, 2.1.5
      naming conventions, 2.1.4
      specific configurations, 2.1.6
    commands
      BACKUP, 2.2.2, 6.9.13
      CATALOG, 10.2.1.2
      CHANGE, 9.2
      EXECUTE SCRIPT, 10.5
      interactive use of, 1.2.2.1
      RESYNC CATALOG, 10.6.3
      standalone commands, 1.2.2.5
      using command files, 1.2.2.2
    compilation and execution of commands, 1.2.1
    configuring
      default device types, 2.1.3
      device types, 2.1.2
    corrupt datafile blocks, 2.12.1, 2.12.2
      handling I/O errors and, 2.11.1
    crosschecking recovery catalog, 9.2
    database connections
      auxiliary database, 4.3
      duplicate database, 4.3
      hiding passwords, 4.5
      with password files, 4.2
    DBMS_PIPE package, 4.7
    duplicate databases
      how created, 13.1.1
    environment
      definition, 1.1
    error codes
      message numbers, 12.1.3.1
    errors, 12.1, 12.1.3
      interpreting, 12.1.4
    file deletion
      overview, 9.3.1
    fractured block detection in, 2.12.3
    hanging backups, 12.4.2
    image copy backups, 2.2.1
    incremental backups
      cumulative, 2.5.1.4
      differential, 2.5.1.3
      level 0, 2.5.1.2
    integrity checking, 2.12
    interactive use of commands, 1.2.2.1
    jobs
      monitoring progress, 9.6.2
    media management
      backing up files, 1.4.1
      Backup Solutions Program (BSP), 1.4.2
      crosschecking, 9.2
      media manager, linking with a, 5.2.2
    metadata, 1.3, 10, 13
      storing in control file, 1.3.1
    monitoring, 9.6, 9.6.4
    multiplexing
      datafiles, 2.2.5
    overview, 1.2
    performance
      monitoring, 9.6
    pipe interface, 4.7
    recovery
      after total media failure, 7.4
    recovery catalog, 1.3.2
      availability, 10.8
      backing up, 10.6.1
      compatibility, 1.3.2.5
      contents, 1.3.2.2
      crosschecking, 9.2
      managing the size of, 10.4
      moving to new database, 10.7
      operating with, 1.3
      operating without, 1.3.1
      recovering, 10.6.3
      registration of target databases, 1.3.2.1, 10.2.1
      resynchronizing, 10.3
      snapshot control file, 1.3.2.3.1
      synchronization, 1.3.2.3
      updating after schema changes, 10.3.3.3
      upgrading, 10.11
    reports, 9.1
      overview, 9.1.2
    restoring
      datafiles, 3.1
      to new host, 7.2
    return codes, 12.1.5
    RPC calls and, 12.4.3
    snapshot control file location, 5.9
    standby databases
      creating, 3.5
    starting, 4.1
    stored scripts, 1.2.2.3
    synchronous and asynchronous I/O, 11.1.2
    tablespace point-in-time recovery, 3.2.4
    tags for backups, 2.4.3
    terminating commands, 12.3
    test disk API, 5.2.3
    types of backups, 2.2.1
    using RMAN commands, 1.2
  recovery window
    point of recoverability, 2.7.1
  recovery windows
    backup optimization and, 2.8.5.1
    definition, 2.7.1
  RECOVERY_PARALLELISM initialization parameter, 18.11
  redo logs
    incompatible format, 21.1
    listing files for backup, 17.1.1
    naming, 18.6.3
    parallel redo, 21.1
  redo records
    problems when applying, 21.1
  REGISTER command, 10.2.1
  REPORT OBSOLETE command, 2.7.3
  reports, 9.1
    obsolete backups, 9.1.2.1
    overview, 9.1.2
  repository
    RMAN, 1.3
  RESET DATABASE command
    INCARNATION option, 10.2.3
  RESETLOGS operation
    when necessary, 18.9.1
  RESETLOGS option
    of ALTER DATABASE, 18.9, 18.9.2, 18.9.2, 18.10.1, 18.10.2
  restartable backups
    definition, 2.9, 6.7
  restarting RMAN backups, 6.7
  RESTORE command, 3.1
    FORCE option, 3.1.4
  restore optimization, 3.1.4
  restoring
    archived redo logs, 18.4.2
    backup control file
      using SET DBID, 7.6.2
    control files
      to default location, 18.5.1.1
      to nondefault location, 18.5.1.2
    database
      to default location, 18.10.1
      to new host, 7.2
      to new location, 18.10.2
    database files, 3.1
      how RMAN chooses, 3.1.2
      mechanics, 3.1.1
      restore optimization, 3.1.4
    datafiles
      to default location, 18.4.1
    to raw devices, 18.4.1
    user-managed backups, 18.2
      keeping records, 17.12
  RESUME clause
    ALTER SYSTEM statement, 17.7.2
  resuming recovery after interruption, 18.6.8
  RESYNC CATALOG command, 10.3
    FROM CONTROLFILECOPY option, 10.6.3
  resynchronizing the recovery catalog, 10.3
  retention policies
    affect on backup optimization, 2.8.5
    definition, 2.7
    disabling, 2.7
    exempt backups, 2.7.4
    recovery window, 2.7
    redundancy, 2.7, 2.7.2
  return codes
    RMAN, 12.1.5
  RMAN. See Recovery Manager

## S

  sbtio.log
    and RMAN, 12.1.1
  sbttest program, 12.2.1
  scenarios, Recovery Manager
    backing up archived redo logs, 6.9.6
    duplexing backup sets, 6.2
    handling backup errors, 6.9.13
    maintaining backups and copies, 6.9.11
    NOARCHIVELOG backups, 6.9.10
    recovering pre-resetlogs backup, 7.1.1
    recovery after total media failure, 7.4
    setting size of backup sets, 6.9.4
  schemas
    changes
      updating recovery catalog, 10.3.3.3
  SCN (system change number)
    use in distributed recovery, 19.11.1
  server parameter files
    autobackups, 2.6
    configuring autobackups, 2.6
  server sessions
    Recovery Manager, 1.1.1
  session architecture
    Recovery Manager, 1.1.1
  SET command
    MAXCORRUPT option, 6.9.13
  SET statement
    AUTORECOVERY option, 18.6.2
    LOGSOURCE variable, 18.4.2, 18.6.6
  shared server
    configuring for use with RMAN, 5.10
  short waits
    definition of, 11.3.5.2
  SHOW command, 2.1.2
  SHUTDOWN statement
    ABORT option, 18.5.1.1, 18.5.1.2, 18.8.1, 18.10.1, 18.10.2
  size of backup sets
    setting, 2.4.4
  SKIP OFFLINE option
    of BACKUP, 6.9.1
  SKIP READONLY option
    of BACKUP, 6.9.1
  snapshot control files, 1.3.2.3.1
    specifying location, 5.9
  split mirrors
    using as backups, 6.3
  splitting mirrors
    suspend/resume mode, 17.7.1
  standalone Recovery Manager commands, 1.2.2.5
  standby databases
    creating using RMAN, 3.5
    updating with incrementals, 13.8.1
  starting RMAN
    without connecting to a database, 4.1
  STARTUP statement
    MOUNT option, 18.8.2, 18.8.3
  stored scripts
    creating RMAN, 10.5.1
    deleting, 10.5.6, 10.5.6, 10.5.6
    managing, 10.5
    Recovery Manager, 1.2.2.3
  stuck recovery
    definition, 21.1
  SUSPEND clause
    ALTER SYSTEM statement, 17.7.2, 17.7.2
  suspending a database, 17.7.1
  suspend/resume mode, 17.7.1
  SWITCH command, 2.2.1.1
  synchronizing duplicate database
    uising DUPLICATE DATABASE, 13.7
    uising incremental backups, 13.8
  system time
    changing
      effect on recovery, 18.8

## T

  tables
    recovery of dropped, 19.10
  tablespace backups
    using RMAN, 6.4, 6.7.1, 6.7.2
  tablespace point-in-time recovery, 8.1.2
    clone database, 20.1.1
    introduction, 20.1
    methods, 20.1.2
    performing
      user-managed, 20
    planning for, 20.2
    procedures for using transportable tablespace feature, 20.4.1, 20.4.2
    requirements, 20.2.1
    terminology, 20.1.1
    transportable tablespace method, 20.1.2
    user-managed, 20.1.2
    using RMAN, 3.2.4
      basic steps, 8.1.2
      introduction, 8.1
      planning, 8.2
      preparing the auxiliary instance, 8.5.1
      restrictions, 8.1.2.1.1
      why perform, 8.1.2
  tablespace transport
    online, 14
  tablespaces
    backups, 17.4.2
      offline, 17.3
      online, 17.4.2
    excluding from RMAN backups, 5.7
    read-only
      backing up, 6.9.1, 17.4.4
    read/write
      backing up, 17.4.1
    recovering offline in open database, 18.7.2
  tags, 2.4.3
  terminating RMAN commands, 12.3
  test databases, creating, 3.4
  test disk API, 5.2.3
  testing RMAN
    backups, 2.12.4, 6.8
    with media management API, 12.2
  time format
    RECOVER DATABASE UNTIL TIME statement, 18.8.4
  time-based recovery, 18.8.4
    coordinated in distributed databases, 19.11.1
  trace files
    and RMAN, 12.1.1
    backing up control file, 17.5.2.1
    control file backups to, 17.5.2
  transparent backup encryption, 6.6.1.1
  transportable tablespace
    cross-platform, 15
    online, 14
  transportable tablespaces
    and CONVERT DATAFILE/TABLESPACE, 15.1
    creating with RMAN, 14.1
      and Data Pump Export, 14.3.3
      and past points in time, 14.3.2
      auxiliary destination, 14.2.2, 14.3.1
      auxiliary instance parameter file, 14.3.4, 14.3.4.2
      Concepts, 14.2
      file locations, 14.3.7
      initialization parameters, 14.3.4.1
      limitations, 14.2.3
      Shared Pool Size, 14.3.5, 14.4.1
      when to use, 14.2.1
    cross-platform, 15.1
    recovery, 19.7
    TSPITR and, 20.1.2
  transporting databases across platforms, 15.2
  trial recovery
    explanation, 21.6.1
    overview, 21.6
  TSPITR, 8.1.2
  TSPITR. See tablespace point-in-time recovery
  tuning
    Recovery Manager
      V$ views, 9.6

## U

  UNAVAILABLE option
    of CHANGE, 9.4
  unrecoverable objects
    and RECOVER operation, 19.5
    recovery
      unrecoverable objects and, 19.5
  unregistering a database from the recovery catalog, 10.2.2
  UNTIL TIME option
    RECOVER command, 18.8.4
  upgrading the recovery catalog, 10.11
  user errors
    recovery from, 19.10
  user-managed backups, 17, 17.2
    backup mode, 17.4.3
    control files, 17.5, 17.5
      binary, 17.5.1
      trace files, 17.5.2
    determining datafile status, 17.1.2
    hot backups, 17.4.3.1
    listing files before, 17.1
    offline dataf, 17.3
    offline tablespaces, 17.3, 17.3
    read-only tablespaces, 17.4.4
    restoring, 18.4.1, 18.4.1
    tablespace, 17.4.2
    verifying, 17.9
    whole database, 17.2.1
  user-managed recovery, 18.8
    ADD DATAFILE operation, 19.2
    complete, 18.7
    incomplete, 18.8
    interrupting, 18.6.8
    opening database after, 18.9
    scenarios, 19
  user-managed restore operations, 18.2
  USING BACKUP CONTROLFILE option
    RECOVER command, 18.8.3

## V

  V$ARCHIVED_LOG view, 3.2.2.1
    listing all archived logs, 17.6
  V$BACKUP view, 17.1.2
  V$BACKUP_ASYNC_IO, 9.6
  V$BACKUP_CORRUPTION view, 2.11.2
  V$BACKUP_SYNC_IO, 9.6
  V$COPY_CORRUPTION view, 2.11.2
  V$DATABASE_BLOCK_CORRUPTION view, 6.8, 7.5.3
  V$DATAFILE view, 17.1.1
    listing files for backups, 17.1
  V$LOG_HISTORY view
    listing all archived logs, 18.4.2
  V$LOGFILE view, 19.8.1, 19.8.2
    listing files for backups, 17.1.1
    listing online redo logs, 17.1.1
  V$PROCESS view, 9.6
  V$RECOVER_FILE view, 18.3
  V$RECOVERY_LOG view
    listing logs needed for recovery, 18.4.2
  V$SESSION view, 9.6
  V$SESSION_LONGOPS view, 9.6
  V$SESSION_WAIT view, 9.6
  V$TABLESPACE view, 17.1.1
  validating
    backups, 6.8
  views
    recovery catalog, 10.9

## W

  wallet, 6.6.1.1
  whole database backups
    ARCHIVELOG mode, 17.2
    inconsistent, 17.2
    NOARCHIVELOG mode, 17.2
    preparing for, 17.2.1